package com.example.mapper;

import com.baomidou.dynamic.datasource.annotation.DS;
import com.example.entity.vo.AttendanceVo;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@DS("attendance")
public interface DeviceAttendanceMapper {

    @Select("SELECT * FROM attendanceSheet WHERE dateTime = #{date} and departmentName in ('生產課','押出課')")
    List<AttendanceVo> depart0(String date);

    @Select("SELECT * FROM attendanceSheet WHERE dateTime = #{date} and departmentName = '裝配課'")
    List<AttendanceVo> depart1(String date);
}
